home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 10 / developer source - volume 10.iso / oracl / mar97 / koopf108.gif < prev   
Graphics Interchange Format  |  1998-02-10  |  14KB  |  632x194  |  4-bit (14 colors)
Labels: text | font | number | screenshot | black and white
OCR: FIGURE 8: The results after deletion of 4,998 rows. The index has the same number of leaf blocks it did when there were 10,000 rows. blkixchk.sql Alloc Lea Avg. Leaf Blocks Avg. Data Blocks Distinct Number Pct. Cluster Index Uniqueness Blocks Level Blocks per Key per Key Keys of Rows Clustering far Raws Estimate Statistics: JKOOPM1.TEST1_PK UNIQUE 515 65 1 9.4 49 1 5.223 5.001 60 58 1.20 -- JKOOPM1.TEST1_PL_AUDT_DT NONUNIQUE 1 1 380 5.001 1,16 Compute Statistics: JKOOPM1.TEST1_PK UNIQUE 515 1 JKOOPM1.TEST1_PL_AUDT_DT 90 1 5,001 58 1,16 NONUNIQUE 65 5,001 1 49 1 1 380 5.001 58 1,16 blkixsts.sql Usable Usable Deleted Const Spoce Space in Deleted Leaf Most Rows Gets B-Tree Used Leol in Leof Branch Branch Branch Leck Rows Repect Der 5pace Space Pct Nome Blocks Block Rows Blocks Block per Row! ength Access (K) Usar .... .. .... JKOOPM1.TEST1_PI_AUDT_DT 49 3924 48 11 3956 34 94 49.00 JKOOPM1.TEST1_PK 3924 89 3956 13 9 192 1 3 345 172 50.00